Trees

Now we have 2 df, the one with all the shade trees and the one with all the trees, which will be used to compare most popular trees later

Stops

We have a problem here. You have stops with the same name because they are on opposite sides of the street. This causes problems down the line when you group by stop, which pairs them up. Let's create a unique ID column that combines the name and id to allow us to group correctly.

Buffer

Spatial Join

Trees

Shade Trees versus All Trees

Next, I'll compare top ten shade trees to top ten of all trees

Examining DBH

I want to separate dbh so that I get the highest number in the range into its own column

  1. indian laurel fig is the smallest of the top 3 trees.
  2. so knowing max dbh is 28 and max branch limb spread is 40-60 feet,
  3. that's a respectable amount of shade for even a 10 ft dbh tree

Trees per Stop

Function

Benches

Spatial join: Benches per stop

Income

Summarized #of trees and benches

Stops with most and least number of trees and benches

Combined analysis